{
  "properties" : { },
  "id" : "49e026c6a3ed4bd08bc1cd42ce725082",
  "script" : null,
  "groupId" : "c0cf605f74e34bc6953194a869f4a6cd",
  "name" : "B查询气象站点信息",
  "createTime" : 1732780546950,
  "updateTime" : 1724225372308,
  "lock" : null,
  "createBy" : "admin",
  "updateBy" : "admin",
  "path" : "/stationinfo",
  "method" : "GET",
  "parameters" : [ {
    "name" : "regioncode",
    "value" : "",
    "description" : "行政区划编码（like 查询） 不传查全部 ",
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "stationkey",
    "value" : "",
    "description" : "站点ID  不传查全部",
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "searchkey",
    "value" : "",
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "orgid",
    "value" : "220024006",
    "description" : "like 平台机构编码",
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"code\": 1,\n    \"message\": \"success\",\n    \"data\": [\n        {\n            \"stationKey\": \"E3230\",\n            \"lat\": 42.6706,\n            \"lon\": 128.9319,\n            \"high\": 488,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙鸡南\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3221\",\n            \"lat\": 42.1003,\n            \"lon\": 128.935,\n            \"high\": 632,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙元峰\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3222\",\n            \"lat\": 42.0458,\n            \"lon\": 128.8117,\n            \"high\": 900,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙广坪\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3223\",\n            \"lat\": 42.1392,\n            \"lon\": 129.0467,\n            \"high\": 570,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙南夕\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3224\",\n            \"lat\": 42.63,\n            \"lon\": 128.98,\n            \"high\": 635,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙源河\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3225\",\n            \"lat\": 42.7306,\n            \"lon\": 128.9392,\n            \"high\": 549,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙香谷\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3226\",\n            \"lat\": 42.7119,\n            \"lon\": 129.0231,\n            \"high\": 417,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙獐项\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3227\",\n            \"lat\": 42.8669,\n            \"lon\": 128.9717,\n            \"high\": 635,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙十里\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3228\",\n            \"lat\": 42.6056,\n            \"lon\": 128.9025,\n            \"high\": 593,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙新百里\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3229\",\n            \"lat\": 42.5644,\n            \"lon\": 128.9039,\n            \"high\": 736,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙东南\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3220\",\n            \"lat\": 42.8144,\n            \"lon\": 128.97,\n            \"high\": 447,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙长仁\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3231\",\n            \"lat\": 42.7486,\n            \"lon\": 128.8706,\n            \"high\": 531.3,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙仲里\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3232\",\n            \"lat\": 42.6864,\n            \"lon\": 129.0756,\n            \"high\": 351.7,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙民俗村\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3233\",\n            \"lat\": 42.6703,\n            \"lon\": 128.8869,\n            \"high\": 521,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙泉水洞\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3234\",\n            \"lat\": 42.815,\n            \"lon\": 128.6769,\n            \"high\": 737,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙庙岭\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3236\",\n            \"lat\": 42.5994,\n            \"lon\": 128.8506,\n            \"high\": 586,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙官地\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3237\",\n            \"lat\": 42.775,\n            \"lon\": 129.3158,\n            \"high\": 287.5,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙兴城气象观测站\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3238\",\n            \"lat\": 42.4425,\n            \"lon\": 128.8619,\n            \"high\": 636,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙青山\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3239\",\n            \"lat\": 42.6069,\n            \"lon\": 129.1872,\n            \"high\": 448,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙东新\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3290\",\n            \"lat\": 42.5033,\n            \"lon\": 128.6464,\n            \"high\": 1344.4,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙先锋林场\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3211\",\n            \"lat\": 42.1942,\n            \"lon\": 129.1725,\n            \"high\": 519.1,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙卢果\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3202\",\n            \"lat\": 42.7542,\n            \"lon\": 129.2053,\n            \"high\": 297,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙头道\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3203\",\n            \"lat\": 42.6056,\n            \"lon\": 128.8417,\n            \"high\": 756,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙甲山\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3204\",\n            \"lat\": 42.6892,\n            \"lon\": 129.1581,\n            \"high\": 315,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙八家子\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3205\",\n            \"lat\": 42.5725,\n            \"lon\": 129.1406,\n            \"high\": 513,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙福洞\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3206\",\n            \"lat\": 42.7258,\n            \"lon\": 129.225,\n            \"high\": 301,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙龙水\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3207\",\n            \"lat\": 42.7417,\n            \"lon\": 129.1053,\n            \"high\": 339,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙龙门\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3208\",\n            \"lat\": 42.6292,\n            \"lon\": 129.0381,\n            \"high\": 384,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙土山子\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3209\",\n            \"lat\": 42.7008,\n            \"lon\": 128.965,\n            \"high\": 429,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙卧龙\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3210\",\n            \"lat\": 42.7517,\n            \"lon\": 129.1017,\n            \"high\": 362,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙药水洞\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3201\",\n            \"lat\": 42.7439,\n            \"lon\": 129.3231,\n            \"high\": 278,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙东城\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3212\",\n            \"lat\": 42.4644,\n            \"lon\": 129.2425,\n            \"high\": 446.8,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙勇化\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3213\",\n            \"lat\": 42.0928,\n            \"lon\": 128.9969,\n            \"high\": 548,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙崇善\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3214\",\n            \"lat\": 42.265,\n            \"lon\": 129.2003,\n            \"high\": 443,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙南坪\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3215\",\n            \"lat\": 42.2469,\n            \"lon\": 128.7831,\n            \"high\": 716,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙百里\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3216\",\n            \"lat\": 42.5456,\n            \"lon\": 128.9567,\n            \"high\": 523,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙大成\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3217\",\n            \"lat\": 42.7656,\n            \"lon\": 129.0169,\n            \"high\": 397,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙青龙\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3218\",\n            \"lat\": 42.3169,\n            \"lon\": 129.085,\n            \"high\": 515,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙仙景台\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        },\n        {\n            \"stationKey\": \"E3219\",\n            \"lat\": 42.3667,\n            \"lon\": 129.0047,\n            \"high\": 678.6,\n            \"city\": \"延边朝鲜族自治州\",\n            \"stationName\": \"和龙车场\",\n            \"cnty\": \"和龙市\",\n            \"code\": \"222406\",\n            \"orgid\": \"220024006\"\n        }\n    ],\n    \"timestamp\": 1724134048846,\n    \"executeTime\": 29\n}",
  "description" : null,
  "requestBodyDefinition" : null,
  "responseBodyDefinition" : null
}
================================
/**
 *    regioncode   行政区划编码  按like查询
 *    stationkey   站点ID
 *    searchkey  关键字筛选查询 中文检索 名称
 */
var sql = """
    select * from station_info  
 
    where 1 = 1 
    <if test="regioncode != null and regioncode != ''" > and code LIKE CONCAT(#{regioncode},'%') </if>
    <if test="orgid != null and orgid != ''" > and orgid LIKE CONCAT(#{orgid},'%') </if>
    <if test="stationkey != null and stationkey != ''\" > and stationkey = #{stationkey} </if>
     <if test="searchkey != null and searchkey != ''\" > and (stationName LIKE CONCAT('%',#{searchkey},'%')  or city LIKE CONCAT('%',#{searchkey},'%') or cnty LIKE CONCAT('%',#{searchkey},'%') or code LIKE CONCAT('%',#{searchkey},'%') or stationKey LIKE CONCAT('%',#{searchkey},'%')  )     </if>
      order by code 
"""

return db.select (sql);